<?php

use Illuminate\Database\Seeder;

class PortalCategoryTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        //  配置
        $sql = 'INSERT INTO `exp_admin_configs` (`id`, `site_id`, `name`, `type`, `title`, `group`, `remark`, `is_developer`, `extra`, `value`, `sort`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 0, \'seo_title\', 1, \'seo标题\', 1, NULL, 0, NULL, \'统景温泉\', 0, NULL, \'2017-11-08 02:56:14\', \'2017-11-09 14:54:20\'),
(2, 0, \'seo_keywords\', 1, \'seo关键字\', 1, NULL, 0, NULL, \'统景温泉,统景,温泉\', 0, NULL, \'2017-11-08 02:56:38\', \'2017-11-09 14:54:20\'),
(3, 0, \'seo_description\', 1, \'seo描述\', 1, NULL, 0, NULL, \'统景温泉\', 0, NULL, \'2017-11-08 02:57:05\', \'2017-11-09 14:54:20\'),
(4, 0, \'home.config.menu_list\', 3, \'导航配置\', 1, \'前端导航\', 1, NULL, \'0=>首页|/\r\n1=>温泉中心|photo/list/1\r\n2=>温泉酒店|photo/list/2\r\n3=>峡谷溶洞|photo/list/3\r\n4=>精彩活动|photo/list/4\r\n5=>网上预订|page/list/5\r\n6=>关于统景|page/list/6\r\n7=>企业公示|news/list/7\', 0, NULL, \'2017-11-08 03:10:00\', \'2017-11-12 18:20:33\'),
(5, 0, \'contact_us\', 2, \'联系我们\', 1, NULL, 0, NULL, \'<h3>联系我们</h3>\r\n<p>温暖热线：<strong>023-67288333</strong></p>\r\n<p>投诉电话：<strong>96960</strong></p>\r\n<div class=\"brd\">\r\n    <h3>中国·重庆·统景温泉</h3>\r\n    <p>重庆市渝北区统景镇景泉路66号</p>\r\n</div>\', 0, NULL, \'2017-11-09 11:02:49\', \'2017-11-09 11:06:21\'),
(6, 0, \'record_info\', 2, \'备案信息\', 1, NULL, 0, NULL, \'<p>Copyright@2010Chongqing Jiaolv All rights</p>\r\n<p>重庆旅游投资集团 渝ICP备</p>\', 0, NULL, \'2017-11-09 11:05:10\', \'2017-11-09 11:05:10\'),
(7, 0, \'common_banner_list\', 2, \'全局Banner图列表\', 1, NULL, 0, NULL, \'<div class=\"m-pic-change\" id=\"slide\" style=\"height: 749px;\">\r\n                     <ul class=\"m-showpic\">\r\n                                           <li style=\"display: list-item; opacity: 0.78449;\"><a href=\"/index.php?r=default/column/content&col=100001&id=142\" target=\"_blank\"><img src=\"/upload/photos/1710121256371831486048.jpg\" alt=\"统景温泉大门\" title=\"统景温泉大门\" border=\"0\"></a></li>\r\n                                         <li style=\"display: none;\"><a href=\"/index.php?r=default/column/content&col=100001&id=130\" target=\"_blank\"><img src=\"/upload/photos/1704221136581301939306.jpg\" alt=\"统景温泉全景图\" title=\"统景温泉全景图\" border=\"0\"></a></li>\r\n                                         <li style=\"display: none;\"><a href=\"/index.php?r=default/column/content&col=100001&id=131\" target=\"_blank\"><img src=\"/upload/photos/150724124428217706821.jpg\" alt=\"统景温泉\" title=\"统景温泉\" border=\"0\"></a></li>\r\n                                        </ul>\r\n                	 <div class=\"hd\">\r\n                     	<ul><li class=\"z-cur\">1</li><li class=\"\">2</li><li class=\"\">3</li></ul>\r\n                     </div>\r\n                </div>\', 0, NULL, \'2017-11-09 16:09:11\', \'2017-11-12 18:20:33\');';
        \Illuminate\Support\Facades\DB::select($sql);

        //  栏目
        $sql = "INSERT INTO `exp_portal_category` (`id`, `site_id`, `title`, `is_page`, `title_en`, `description`, `is_allow_content`, `cover_id`, `cover`, `document_type`, `document_thumb_wh`, `pid`, `seo_title`, `seo_description`, `seo_keywords`, `page_limit`, `template_index`, `template_list`, `template_detail`, `is_disabled`, `create_name`, `create_auth`, `more`, `ip`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 0, '温泉中心', 0, NULL, NULL, 0, 0, '/upload/image/201711/060928377804.jpg', 'photo', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 15:37:10', '2017-11-08 20:46:03'),
(2, 0, '温泉酒店', 0, NULL, NULL, 0, 0, '', 'photo', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 15:37:28', '2017-11-07 17:52:37'),
(3, 0, '峡谷溶洞', 0, NULL, NULL, 0, 0, '', 'photo', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 15:37:51', '2017-11-07 17:52:40'),
(4, 0, '精彩活动', 0, NULL, NULL, 0, 0, '', 'photo', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 15:38:21', '2017-11-07 17:52:44'),
(5, 0, '网上预订', 1, NULL, NULL, 1, 0, '', 'page', NULL, 0, NULL, NULL, NULL, 0, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 15:42:35', '2017-11-08 18:08:16'),
(6, 0, '关于统景', 0, NULL, NULL, 0, 0, NULL, 'page', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:12:32', '2017-11-08 18:16:53'),
(7, 0, '企业公示', 0, NULL, NULL, 1, 0, NULL, 'news', NULL, 0, NULL, NULL, NULL, 20, NULL, 'document.list.news', 'document.detail.news', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:16:12', '2017-11-07 17:53:00'),
(8, 0, '温泉泡池', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 1, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:17:50', '2017-11-07 16:17:50'),
(9, 0, '水疗馆', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 1, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:26:49', '2017-11-07 16:26:49'),
(10, 0, '休闲美食', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 1, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:26:59', '2017-11-07 17:55:48'),
(11, 0, 'SPA', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 1, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:27:08', '2017-11-07 17:55:51'),
(12, 0, '温泉汤院', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 2, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:27:36', '2017-11-07 17:55:19'),
(13, 0, '酒店客房', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 2, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:27:46', '2017-11-07 17:55:22'),
(14, 0, '会议中心', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 2, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:27:58', '2017-11-07 17:55:26'),
(15, 0, '酒店美食', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 2, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:28:06', '2017-11-07 17:55:29'),
(16, 0, '统景小三峡', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 3, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:28:31', '2017-11-07 17:54:40'),
(17, 0, '天然溶洞', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 3, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:28:40', '2017-11-07 17:54:43'),
(18, 0, '最新活动', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 4, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:29:40', '2017-11-07 17:54:12'),
(19, 0, '活动回顾', 0, NULL, NULL, 1, 0, NULL, 'photo', NULL, 4, NULL, NULL, NULL, 20, NULL, 'document.list.photo', 'document.detail.photo', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:29:52', '2017-11-07 17:54:15'),
(20, 0, '统景历史', 1, NULL, NULL, 1, 0, NULL, 'page', NULL, 6, NULL, NULL, NULL, 20, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:30:36', '2017-11-08 18:15:55'),
(21, 0, '统景文化', 1, NULL, NULL, 1, 0, NULL, 'page', NULL, 6, NULL, NULL, NULL, 20, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:34:42', '2017-11-08 18:15:46'),
(22, 0, '统景特产', 1, NULL, NULL, 1, 0, NULL, 'page', NULL, 6, NULL, NULL, NULL, 20, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:34:50', '2017-11-08 18:16:14'),
(23, 0, '统景交通', 1, NULL, NULL, 1, 0, NULL, 'page', NULL, 6, NULL, NULL, NULL, 20, NULL, 'document.list.page', 'document.detail.page', 0, NULL, 0, NULL, NULL, NULL, '2017-11-07 16:34:58', '2017-11-08 18:15:40');";
        \Illuminate\Support\Facades\DB::select($sql);

        //  文档
        $sql = "INSERT INTO `exp_portal_document` (`id`, `site_id`, `pid`, `title`, `description`, `color`, `create_uid`, `create_name`, `category_id`, `document_type`, `cover_id`, `cover`, `source_id`, `click`, `support`, `comment`, `collect`, `sort`, `status`, `is_audit`, `fixed_release_time`, `more`, `ip`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 0, 0, '网上预订', NULL, NULL, 0, NULL, 5, 'page', 0, NULL, 0, 0, 0, 0, 0, 0, 99, 99, '2017-11-09 02:46:23', NULL, NULL, NULL, '2017-11-08 18:46:23', '2017-11-08 18:48:29'),
(2, 0, 0, '统景历史', '', NULL, 0, NULL, 20, 'page', 0, NULL, 0, 0, 0, 0, 0, 0, 99, 99, '2017-11-09 02:50:17', NULL, NULL, NULL, '2017-11-08 18:50:17', '2017-11-08 18:50:17'),
(3, 0, 0, '统景文化', '', NULL, 0, NULL, 21, 'page', 0, NULL, 0, 0, 0, 0, 0, 0, 99, 99, '2017-11-09 02:50:28', NULL, NULL, NULL, '2017-11-08 18:50:28', '2017-11-08 18:50:28'),
(4, 0, 0, '统景特产', '', NULL, 0, NULL, 22, 'page', 0, NULL, 0, 0, 0, 0, 0, 0, 99, 99, '2017-11-09 02:50:32', NULL, NULL, NULL, '2017-11-08 18:50:32', '2017-11-08 18:50:32'),
(5, 0, 0, '统景交通', NULL, NULL, 0, NULL, 23, 'page', 0, NULL, 0, 0, 0, 0, 0, 0, 99, 99, '2017-11-09 02:50:37', NULL, NULL, NULL, '2017-11-08 18:50:37', '2017-11-08 18:52:15');";
        \Illuminate\Support\Facades\DB::select($sql);

        $sql = "INSERT INTO `exp_portal_document_page` (`id`, `seo_title`, `seo_description`, `seo_keywords`, `template_detail`, `content`, `pic_text`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, NULL, 'document.detail.page', NULL, '[]', NULL, '2017-11-08 10:46:23', '2017-11-08 10:48:29'),
(2, '', '', '', 'document.detail.page', '', '[]', NULL, '2017-11-08 10:50:17', '2017-11-08 10:50:17'),
(3, '', '', '', 'document.detail.page', '', '[]', NULL, '2017-11-08 10:50:28', '2017-11-08 10:50:28'),
(4, '', '', '', 'document.detail.page', '', '[]', NULL, '2017-11-08 10:50:32', '2017-11-08 10:50:32'),
(5, NULL, NULL, NULL, 'document.detail.page', NULL, '[]', NULL, '2017-11-08 10:50:37', '2017-11-08 10:52:15');";
        \Illuminate\Support\Facades\DB::select($sql);

        $sql = "INSERT INTO `exp_basic_link` (`id`, `site_id`, `title`, `links`, `cover_id`, `cover`, `owner`, `description`, `sort`, `status`, `ip`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 0, '重庆旅投', 'http://www.cqtic.net/', 0, NULL, NULL, NULL, 0, 99, NULL, NULL, '2017-11-09 18:02:36', '2017-11-09 18:02:36'),
(2, 0, '千番旅行', 'http://www.1000fun.com/', 0, NULL, NULL, NULL, 0, 99, NULL, NULL, '2017-11-09 18:02:56', '2017-11-09 18:02:56'),
(3, 0, '金佛山', 'http://www.517jfs.com/', 0, NULL, NULL, NULL, 0, 99, NULL, NULL, '2017-11-10 00:12:29', '2017-11-10 00:12:29'),
(4, 0, '乌江画廊', 'http://www.wujianghualang.com/', 0, NULL, NULL, NULL, 0, 99, NULL, NULL, '2017-11-10 00:15:03', '2017-11-10 00:15:03'),
(5, 0, '乐和乐都', 'http://www.leheledu.com/', 0, NULL, NULL, NULL, 0, 99, NULL, NULL, '2017-11-10 00:15:19', '2017-11-10 00:15:19');";
        \Illuminate\Support\Facades\DB::select($sql);

        $sql = "INSERT INTO `exp_basic_adv` (`id`, `site_id`, `name`, `title`, `description`, `type`, `click`, `more`, `cover_id`, `cover`, `number`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 0, 'home_top_banner_list', '门户站banner列表', '门户站banner列表', 3, 0, NULL, 0, NULL, 3, NULL, '2017-11-12 22:23:09', '2017-11-12 22:25:05'),
(2, 0, 'home_index_desc', '门户站首页简介列表', NULL, 3, 0, NULL, 0, NULL, 8, NULL, '2017-11-12 22:40:28', '2017-11-12 22:43:14');";

        \Illuminate\Support\Facades\DB::select($sql);

        $sql = "INSERT INTO `exp_basic_adv_data` (`id`, `adv_id`, `title`, `big_title`, `description`, `content`, `links`, `cover_id`, `cover`, `click`, `sort`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, '统景温泉大门', NULL, NULL, '/upload/image/201711/131429431422.jpg', NULL, 0, NULL, 0, 1, NULL, '2017-11-12 22:30:09', '2017-11-12 22:30:09'),
(2, 1, '统景温泉全景图', NULL, NULL, '/upload/image/201711/131429434529.jpg', NULL, 0, NULL, 0, 2, NULL, '2017-11-12 22:30:31', '2017-11-12 22:30:31'),
(3, 1, '统景温泉', NULL, NULL, '/upload/image/201711/131429431355.jpg', NULL, 0, NULL, 0, 3, NULL, '2017-11-12 22:30:57', '2017-11-12 22:30:57'),
(4, 2, '温泉中心', '养生温泉中心 全面健康呵护', '统景温泉，坐落于湖光山色之中的养生秘境，温泉中心室内、外共48个泉池，分为4个大组团，分别是生态养气温泉组团、文化养神温泉组团、禅意养心温泉组团、 水上游乐温泉组团。', '/upload/image/201711/131456518534.jpg', 'photo/list/1', 0, NULL, 0, 1, NULL, '2017-11-12 23:02:47', '2017-11-12 23:02:47'),
(5, 2, '冷泉', '冰火两重天 激情一整夏', '冰火两重天 激情一整夏 除温泉外，统景温泉还有特色冷泉，统景温泉是大陆首家开发冷泉产品的景区，冷泉水质清澈透明，可饮可浴，具有美肤养颜、促进血液循环、提高免疫力的功效。冷泉水温常年低于20℃，为炎炎夏日带来清凉乐趣。', '/upload/image/201711/131456515022.jpg', NULL, 0, NULL, 0, 2, NULL, '2017-11-12 23:09:41', '2017-11-12 23:09:41'),
(6, 2, '酒店', '温泉养生酒店 尽享惬意时光', '统景温泉酒店，集养生理疗于一体的健康管理中心式酒店，拥有316套客房，485个床位。房型种类繁多，包括标间、单间、套房、豪华套房、半山别院、温泉汤院等，可完美匹配不同顾客的消费需求。', '/upload/image/201711/131456512575.jpg', NULL, 0, NULL, 0, 3, NULL, '2017-11-12 23:10:32', '2017-11-12 23:11:24'),
(7, 2, '会议', '完善商务配套 匹配精英人生', '统景温泉拥有专业的商务会议场所，6个会议室，可容纳650人同时召开会议，包括可容纳210人的大型会议室。先进的会议设施、一流的议事环境和专业周到的服务，为您举行高端商务活动提供绝佳场所。', '/upload/image/201711/131456513254.jpg', NULL, 0, NULL, 0, 4, NULL, '2017-11-12 23:12:40', '2017-11-12 23:12:40'),
(8, 2, '汤院', '顶级贵宾汤院 完美度假体验', '贵宾汤院是统景温泉高端商务接待区，依山面水，风景秀丽，极具独立性、私密性。咖啡厅、SPA馆、足疗区、运动健身区、乒乓球室、桌球室、麻将桌、游戏大厅、KTV等商务及娱乐配套设施一应俱全，尽享完美度假时光。', '/upload/image/201711/131456518735.jpg', NULL, 0, NULL, 0, 5, NULL, '2017-11-12 23:13:17', '2017-11-12 23:13:17'),
(9, 2, '景区', '访武陵仙境 游统景“小三峡”', '统景温泉一揽山、水、林、泉、峡、洞、瀑、古寨诸景，被历代文人墨客盛赞为“武陵仙境”。环顾四周，统景小三峡异峰巧石，鹰飞猿跃；双峰山山峦起伏，沉稳如初；感应洞玲珑剔透，深邃神秘；温塘河碧波荡漾，水趣盎然……', '/upload/image/201711/131456513737.jpg', NULL, 0, NULL, 0, 6, NULL, '2017-11-12 23:13:57', '2017-11-12 23:13:57'),
(10, 2, '夏季套餐', '夏季清凉套餐 尽享冷热双泉', '重庆统景温泉礼献全城，倾情推出特色冷泉和特惠套餐，为酷暑时节带来清凉乐趣，畅享激情一夏！快带上您的家人朋友，一起相约统景，来一次刺激的反季温泉之旅吧！', '/upload/image/201711/131456513923.jpg', NULL, 0, NULL, 0, 7, NULL, '2017-11-12 23:14:28', '2017-11-12 23:14:28'),
(11, 2, '仅有图片', NULL, NULL, '/upload/image/201711/131456516672.jpg', NULL, 0, NULL, 0, 8, NULL, '2017-11-12 23:17:50', '2017-11-12 23:17:50');";
        \Illuminate\Support\Facades\DB::select($sql);

    }
}
